SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Nestled on 100 acres of pristine countryside, this expansive log home offers the perfect blend of rustic charm, modern comfort, and investment potential. With 3 bedrooms and two ¾ bathrooms, the main residence features spacious first-floor living and a warm, inviting layout ideal for families or groups. Generous living areas on both the main and upper levels provide flexible space for entertaining or relaxing, while the second-story enclosed porch/sunroom showcases breathtaking mountain views—an ideal spot to unwind year-round. Currently operating as a successful short-term rental, the home also includes a bright and airy in-law apartment with its own entrance, one bedroom, and a ¾ bathroom—perfect for extended family, guests, or additional rental income. Natural wood finishes and an open-concept design add to the home’s cozy appeal, creating a welcoming atmosphere throughout. Whether you're looking to explore, expand, or simply enjoy, the sprawling 100-acre property invites endless possibilities: hike, ride, hunt, or consider future development or agricultural use. Whether you're looking for a full-time residence, a family retreat, or a business opportunity in Vermont’s scenic countryside, this one-of-a-kind log home delivers. Don't miss your chance to own a true Vermont escape with modern comfort, privacy, and unmatched natural beauty.
Description:A refined lakeside retreat with views of Mascoma Lake and a short walk to two shared sandy beaches, this beautifully maintained 3-bedroom, 3-bath home offers an exceptional balance of comfort and connection to nature. A rare opportunity, the property conveys with a boat slip on Mascoma Lake, allowing you to keep your boat in the water for $300 per year (plus a one-time $2,000 buy-in fee). The slip is optional and may transfer within the association if a future owner chooses not to continue it. Thoughtfully designed for both everyday living and relaxed entertaining, the home features a seamless flow from the living room—anchored by a wood-burning fireplace—to the dining area and through French doors to a screened porch with lake views, where summer evenings are defined by soft breezes and the unmistakable call of loons across the water. The kitchen is appointed with granite countertops, and the first floor also offers a versatile bedroom or office, full bath, and practical mudroom. Upstairs, the primary suite provides a private retreat with vaulted ceilings, a walk-in closet, and an ensuite full bath, along with an additional bedroom and full bath. The lower level expands the living space with a generous bonus room ideal for a family room, fitness area, or creative studio, plus a dedicated laundry room, storage room, utility room, and direct exterior access from the basement. Set within a quiet, well-kept community where outdoor recreation is just steps away—yet only minutes to I-89, Dartmouth Hitchcock, Dartmouth College, dining, and shopping—this home offers a rare blend of lake lifestyle and Upper Valley convenience.
Description:Own a piece of early New England history with waterfront — a rare combination that almost never comes available. This iconic 1812 stone home sits on a level 0.98-acre lot and includes 130 feet of owned Connecticut River frontage just across the quiet country road, offering easy access for kayaking, fishing, paddle boarding, or simply enjoying the ever-changing water views. Inside, the home blends historic character with comfortable living. The first floor offers a warm and inviting living room with wood stove, country kitchen with dining nook, formal dining room, first-floor bedroom, half bath, sun porch, workshop space, and generous storage. Upstairs you'll find a large primary bedroom, office, and full bath, while the third level provides an additional bedroom and flexible bonus space perfect for guests, studio, or work-from-home use. Original details remain throughout — maple floors on the main level, wide pine floors above, and deep farmhouse window trim — creating the charm only a true period home can offer. Outside, the property is equally special, with mature landscaping, established garden areas, patio space, and a workshop/shed. The river frontage across the road expands the lifestyle, giving you your own personal access to the Connecticut River without sacrificing privacy at the house site. Conveniently located just minutes to I-91 and an easy bike ride to Post Pond and Cedar Circle Farm, this property offers a unique blend of history, recreation, and rural tranquility — a setting increasingly difficult to find in the Upper Valley. Just a 20 minute drive to downtown Hanover & Dartmouth College. High School Choice.
Description:This 3 bed, 3 bath home is perfectly situated in the desirable Fieldstone Ridge neighborhood with views to Cardigan Mountain. You will fall in love with the light filled, open concept spaces including a wonderful sunroom with seasonal views of the Whaleback ski area ridge line. Enjoy the ease of one level living with a primary suite with a double sided propane fireplace, beautifully renovated 3/4 bath and a large walk-in closet as well as a designated laundry space all conveniently located on the main level. Upstairs there are 2 oversized bedrooms and a full bath. Still need more space? The full walk out basement is unfinished but has endless possibilities to add more living space, an office, exercise area and workshop. Bring your ideas and join this lovely community. Neighbors gather for hikes, snow shoeing and annual parties if you wish. Otherwise keep to yourself and enjoy the easy accessibility to downtown Lebanon, Dartmouth Health within 15 mins and Hanover just under 20 minutes away. The perfect spot to enjoy the Upper Valley lifestyle. Showings begin on Friday 3/27 at the Open House from 12-2. Saturday Open House 10-12.